USE [NLKHCNData]
GO

/****** Object:  StoredProcedure [dbo].[DeleteLinhVuc]    Script Date: 12/25/2014 11:26:30 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- 2014-12-25: hien created
-- =============================================
CREATE PROCEDURE [dbo].[DeleteNhomLinhVuc] 
	@id int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    update LinhVuc set NhomLinhVucId = null where NhomLinhVucId = @id;
	
	Delete NhomLinhVuc Where Id = @id;
END




GO


